Spread WPF Documentation
Evaluate(Object[]) Method


The args contains 2 - 3 items: start_date, days, [holidays].

Start_date is a date that represents the start date.

Days is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.

[Holidays] is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) of the serial numbers that represent the dates.

Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date).
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object
'Usage
 
Dim instance As CalcWorkdayFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)
public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 2 - 3 items: start_date, days, [holidays].

Start_date is a date that represents the start date.

Days is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.

[Holidays] is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) of the serial numbers that represent the dates.

Return Value

A System.Double value that indicates the evaluate result.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

CalcWorkdayFunction Class
CalcWorkdayFunction Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.